<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="com.ace.utils.ExcelUtil"%>
<%@page import="com.ace.dao.StudentDao"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title></title>
    <link rel="stylesheet" type="text/css" href="../css/style.css">

    <style type="text/css">
    #download{
    	margin:50px;
    }
    </style>
  </head>
  
  <body>
	<div id="top">
	  	
	  	<div class="logbgcc">
		    <%
		   	List<HashMap<String,Object>> Students = StudentDao.queryStudents();
		   	String path = request.getRealPath("/")+"/students.xls";
		   	ExcelUtil.exportExcelData(Students,path);	
		   	out.print("<a href='/login/students.xls'>下载名单</a>");
		    %></div>
		    <div class="logbgcc">
		   	<a href="${pageContext.request.contextPath }/index.jsp">返回首页</a>
		</div>	 
	</div>
  <div id="container"><div></div></div>
  
    
  </body>
</html>
